Executive Summary
23
********************************************************************
Executive Summary
********************************************************************
This Executive Summary section is a two part section.
- GIF
- Troubles that occurred on the Project
GIF - Your gif will take up the whole slide
Dashboard
- The gif should include you making random selections in your dashboard
- Click on at least one entry in every dimension
- If your dashboard has drill down or drill through features, ensure you show that
- If your dashboard has a map, make sure you click on that
- Give a second or two between clicks so people can see how the data reacts
- Include the calculation
ETL or Process
- Create a Power Point presentation and create the GIF while on full screen
- The GIF will consist of you clicking through your Power Point Presentation
- At this point you've already broken down your project step by step in the stress test
- You will break your presentation down in a similar fashion. Each step will have a...
1. Black Screen with Big White Font
2. No more than 6 words per step
3. Step will show up in the same place on every slide
3. Colaberry Logo
4. Each Slide will show for 2 seconds
5. In between each step will be the screenshots of the work done in that step. This includes screenshots from the Database, ETL package, code etc...
a. If you only have one slide for the step, you will show it for 2 seconds
b. If you have more than one slide for the step, you show each slide for one second each
6. The end result is a 20-30 second (Under 5MB) fast pace moving GIF that summaries everything you've completed in the project. This will represent the visual needed to showcase the great work you put in on the project.
Troubles that occurred on the Project
- This section will be in two parts - Text & Pictures
- If you followed the Project Checklist, you have already documented problems that occurred on your project
- In the text portion, you will give 2-3 problems that occurred in text.
- Each step should be numbered
- In the Pictures section you will find a picture that represents each problem.
- In the pictures, you could take screenshots of actual parts of your project or you could show pictures that relate to your problem. Remember to always capture the hearts of the audience.
- Numbers must be numbered with same font / size / text / color to keep consistency
- There should be no titles except before the numbered steps
Dashboard Example:

Problems that occurred During Project
1. Start working on this data set, the data was subset of the data, so the solutions was that the data set got fixed by the company.
2. having right company’s KPI by analyzing the data. finally, one of the company’s KPI’s was year over year, but in this data set there is only 20 months, so I cannot use year over. And then, instead of using the year over year calculation, changed to month over month.

